Tabela CO_DICTMEAL

Definicja tabeli CO_DICTMEAL

Name

CO_DICTMEAL

Code

CO_DICTMEAL

Comment

 


Lista kolumn tabeli CO_DICTMEAL

Name

Code

CO_DICTMEALID

CO_DICTMEALID

NAME

NAME

SHORTNAME

SHORTNAME

ACTIVE

ACTIVE

SORT

SORT

STARTDT

STARTDT

STOPDT

STOPDT

CODE

CODE

MEALTYPEID

MEALTYPEID

TIMELIMIT

TIMELIMIT

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT


Kolumna CO_DICTMEALID tabeli CO_DICTMEAL

Definicja kolumny CO_DICTMEALID tabeli CO_DICTMEAL

Name

CO_DICTMEALID

Code

CO_DICTMEALID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna NAME tabeli CO_DICTMEAL

Definicja kolumny NAME tabeli CO_DICTMEAL

Name

NAME

Code

NAME

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna SHORTNAME tabeli CO_DICTMEAL

Definicja kolumny SHORTNAME tabeli CO_DICTMEAL

Name

SHORTNAME

Code

SHORTNAME

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna ACTIVE tabeli CO_DICTMEAL

Definicja kolumny ACTIVE tabeli CO_DICTMEAL

Name

ACTIVE

Code

ACTIVE

Data Type

NUMBER(5)

Mandatory

Yes

Comment

 


Kolumna SORT tabeli CO_DICTMEAL

Definicja kolumny SORT tabeli CO_DICTMEAL

Name

SORT

Code

SORT

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna STARTDT tabeli CO_DICTMEAL

Definicja kolumny STARTDT tabeli CO_DICTMEAL

Name

STARTDT

Code

STARTDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna STOPDT tabeli CO_DICTMEAL

Definicja kolumny STOPDT tabeli CO_DICTMEAL

Name

STOPDT

Code

STOPDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna CODE tabeli CO_DICTMEAL

Definicja kolumny CODE tabeli CO_DICTMEAL

Name

CODE

Code

CODE

Data Type

VARCHAR2(20)

Mandatory

Yes

Comment

 


Kolumna MEALTYPEID tabeli CO_DICTMEAL

Definicja kolumny MEALTYPEID tabeli CO_DICTMEAL

Name

MEALTYPEID

Code

MEALTYPEID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna TIMELIMIT tabeli CO_DICTMEAL

Definicja kolumny TIMELIMIT tabeli CO_DICTMEAL

Name

TIMELIMIT

Code

TIMELIMIT

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna INSERTDATE tabeli CO_DICTMEAL

Definicja kolumny INSERTDATE tabeli CO_DICTMEAL

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_DICTMEAL

Definicja kolumny INSERTINGPERSON tabeli CO_DICTMEAL

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_DICTMEAL

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_DICTMEAL

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_DICTMEAL

Definicja kolumny LASTMODIFIEDDT tabeli CO_DICTMEAL

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli CO_DICTMEAL

Name

Code

Primary

PK_CO_DICTMEAL

PK_CO_DICTMEAL

X


Klucz PK_CO_DICTMEAL tabeli CO_DICTMEAL

Definicja klucza PK_CO_DICTMEAL tabeli CO_DICTMEAL

Name

PK_CO_DICTMEAL

Code

PK_CO_DICTMEAL

Primary

Yes

Comment